const router = require('koa-router')()
const db = require("../config/db");

router.get('/', async (ctx, next) => {

  var db = db;
  // console.log(db);
  var sqlSelect = "select * from blog";
  var result = await db.query(sqlSelect,[]);
  console.log(result);
  var chapterList = result;
  await ctx.render('index', {
    chapterList: chapterList
  })
})

router.get('/detail/:id',async (ctx,next) => {
  var blogId = ctx.params.id;
  var selectSql = "select * from blog where blogId = 1"
  var result = await db.query(selectSql,[blogId]);
  //访问：
  await ctx.render('detail', {
    chapter:result[0]
  })
})

router.get('/string', async (ctx, next) => {
  ctx.body = 'koa2 string'
})

router.get('/json', async (ctx, next) => {
  ctx.body = {
    title: 'koa2 json'
  }
})

module.exports = router
